Mega Code Archive
Linear Regression Functions
1) For another equivalent test statistic
2) For average value of dependent (y) variables
3) For average value of independent (x) variables
4) For between degrees of freedom (DF)
5) For between sum of squares (SS)
6) For chi-square degrees of freedom
7) For chi-square significance level
8) For chi-square value
9) For degrees of freedom
10) For degrees of freedom (DF)
11) For F statistic
12) For mean square (MS) between
13) For mean square (MS) within
14) For one-tailed significance level
15) For other related test statistics
16) For significance level
17) For significance level for one-sided test
18) For significance level for two-sided test
19) For significance level of one-sided test
20) For significance level of two-sided test
21) For sum of cross-product xy
22) For sum of squares x
23) For sum of squares y
24) For the coefficient of determination (R-square)
25) For the number of observations
26) For the test statistic value
27) For the y-intercept of the line
28) For two-tailed significance level
29) For within degrees of freedom (DF)
30) For within sum of squares (SS)
31) REGR_AVGX returns the average of x after eliminating x and y pairs where either x or y is null
32) REGR_COUNT(salary, city) AS count
33) REGR_SLOPE(expr1, expr2) gives a least square regression line to a set of pairs of numbers
34) REGR_SYY(salary, city) AS syy
35) SELECT STATS_WSR_TEST(value, id, ONE_SIDED_SIG)
36) STATS_CROSSTAB(expr1, expr2, COHENS_K)
37) STATS_CROSSTAB(expr1, expr2, CONT_COEFFICIENT)
38) STATS_CROSSTAB(expr1, expr2, CRAMERS_V)
39) STATS_F_TEST(expr1, expr2, DF_DEN)
40) STATS_MODE(expr) returns the mode of a set of numbers
41) STATS_MW_TEST(expr1, expr2, STATISTIC)
42) STATS_T_TEST_INDEPU(expr1, expr2, STATISTIC)
43) Stats_T_Test_One
44) STATS_T_TEST_PAIRED(expr1, expr2, STATISTIC)
45) STATS_WSR_TEST(expr1, expr2, STATISTIC)
46) STDDEV([DISTINCT ALL] value) [OVER (analytic_clause)] returns the standard deviation value
47) STDDEV_SAMP(expr) [OVER(analytic_clause)] computes the cumulative sample standard deviation
48) Using the Linear Regression Functions
49) VAR_POP(expr) calculates the population variance
50) VAR_SAMP(expr) calculates the sample variance
51) VARIANCE([DISTINCT ALL] expr) gives the variance of all values of a group of rows